package com.wolf.etl.constant;

/**
 * @author sdyang
 * @date 2019/11/18 10:43
 **/
public interface SqlConstant {

    String FORMAT_AND_FIELD = " and %s=%s ";
    String FORMAT_PREFFIX_FIELD = " %s.%s ";
    String FORMAT_TABLE_ALIAS = " %s %s ";
    String FORMAT_STRING = " '%s' ";
    String COMMA = ",";
    String SINGLE_QUOTE = "'";
    String FORMAT_UPDATE_FIELD = " %s=%s ";
    String FORMAT_UPDATE_SQL = "update %s %s set %s where 1=1 %s";
    String UNDERSCORE = "_";
    String EMPTY = "";
    String SET = " set ";
    String VALUE = "value";
    String WHERE = " where 1=1 ";
    String ORDER_BY = " order by ";
    String ORDER_BY_ASC = " asc ";
    String ORDER_BY_DESC = " desc ";
    String FORMAT_SELECT_SQL = "select %s from %s %s %s";
    String FORMAT_COUNT_SQL = "select count(1) record_count from %s %s ";
    String FORMAT_INSERT_SQL = "insert into %s(%s)values(%s)";
    String FORMAT_INSERT_SELECT_SQL = "insert into %s(%s) select %s from %s %s";
}
